﻿namespace DataAccessLogic
{
    public static class StoredProcedures
    {
        public const string USP_APPUSER_CREATE = "USP_APPUSER_CREATE";
        public const string USP_APPUSER_DELETE = "USP_APPUSER_DELETE";
        public const string USP_APPUSER_GETALL = "USP_APPUSER_GETALL";
        public const string USP_APPUSER_GETACTIVE = "USP_APPUSER_GETACTIVE";
                        
        public const string USP_CONSTITUENT_GETALL = "USP_CONSTITUENT_GETALL";
        public const string USP_CONSTITUENT_GETACTIVE = "USP_CONSTITUENT_GETACTIVE";
        public const string USP_CONSTITUENT_GETACTIVEPRIMARIES = "USP_CONSTITUENT_GETACTIVEPRIMARIES";
        public const string USP_CONSTITUENT_GETBYID = "USP_CONSTITUENT_GETBYID";
        public const string USP_CONSTITUENT_CREATE = "USP_CONSTITUENT_CREATE";
        public const string USP_CONSTITUENT_DELETE = "USP_CONSTITUENT_DELETE";
        public const string USP_CONSTITUENT_MARKINACTIVE = "USP_CONSTITUENT_MARKINACTIVE";
        public const string USP_CONSTITUENT_MARKACTIVE = "USP_CONSTITUENT_MARKACTIVE";
        public const string USP_CONSTITUENT_REMOVEASPRIMARY = "USP_CONSTITUENT_REMOVEASPRIMARY";
        public const string USP_CONSTITUENT_UPDATE = "USP_CONSTITUENT_UPDATE";

        public const string USP_ADDRESS_GETALLBYCONSTITUENTID = "USP_ADDRESS_GETALLBYCONSTITUENTID";
        public const string USP_ADDRESS_GETPRIMARYBYCONSTITUENTID = "USP_ADDRESS_GETPRIMARYBYCONSTITUENTID";
        public const string USP_ADDRESS_GETACTIVEBYCONSTITUENTID = "USP_ADDRESS_GETACTIVEBYCONSTITUENTID";
        public const string USP_ADDRESS_GETBYADDRESSID = "USP_ADDRESS_GETBYADDRESSID";
        public const string USP_ADDRESS_CREATE = "USP_ADDRESS_CREATE";
        public const string USP_ADDRESS_DELETE = "USP_ADDRESS_DELETE";
        public const string USP_ADDRESS_UPDATE = "USP_ADDRESS_UPDATE";
        public const string USP_ADDRESS_DELETEBYCONSTITUENTID = "USP_ADDRESS_DELETEBYCONSTITUENTID";

        public const string USP_EMAILADDRESS_GETALLBYCONSTITUENTID = "USP_EMAILADDRESS_GETALLBYCONSTITUENTID";
        public const string USP_EMAILADDRESS_GETACTIVEBYCONSTITUENTID = "USP_EMAILADDRESS_GETACTIVEBYCONSTITUENTID";
        public const string USP_EMAILADDRESS_GETPRIMARYBYCONSTITUENTID = "USP_EMAILADDRESS_GETPRIMARYBYCONSTITUENTID";
        public const string USP_EMAILADDRESS_GETBYEMAILADDRESSID = "USP_EMAILADDRESS_GETBYEMAILADDRESSID";
        public const string USP_EMAILADDRESS_CREATE = "USP_EMAILADDRESS_CREATE";
        public const string USP_EMAILADDRESS_DELETE = "USP_EMAILADDRESS_DELETE";
        public const string USP_EMAILADDRESS_UPDATE = "USP_EMAILADDRESS_UPDATE";
        public const string USP_EMAILADDRESS_DELETEBYCONSTITUENTID = "USP_EMAILADDRESS_DELETEBYCONSTITUENTID";

        public const string USP_PHONE_GETALLBYCONSTITUENTID = "USP_PHONE_GETALLBYCONSTITUENTID";
        public const string USP_PHONE_GETACTIVEBYCONSTITUENTID = "USP_PHONE_GETACTIVEBYCONSTITUENTID";
        public const string USP_PHONE_GETPRIMARYBYCONSTITUENTID = "USP_PHONE_GETPRIMARYBYCONSTITUENTID"; 
        public const string USP_PHONE_GETBYPHONEID = "USP_PHONE_GETBYPHONEID";
        public const string USP_PHONE_CREATE = "USP_PHONE_CREATE";
        public const string USP_PHONE_DELETE = "USP_PHONE_DELETE";
        public const string USP_PHONE_UPDATE = "USP_PHONE_UPDATE";
        public const string USP_PHONE_DELETEBYCONSTITUENTID = "USP_PHONE_DELETEBYCONSTITUENTID";


        //code table sprocs
        public const string USP_CODETABLECATALOG_CREATE = "USP_CODETABLECATALOG_CREATE";
        public const string USP_CODETABLECATALOG_DELETE = "USP_CODETABLECATALOG_DELETE";
        public const string USP_CODETABLECATALOG_UPDATE = "USP_CODETABLECATALOG_UPDATE";

        public const string USP_ADDRESSTYPECODE_CREATE = "USP_ADDRESSTYPECODE_CREATE";
        public const string USP_ADDRESSTYPECODE_DELETE = "USP_ADDRESSTYPECODE_DELETE";
        public const string USP_ADDRESSTYPECODE_GETALL = "USP_ADDRESSTYPECODE_GETALL";
        public const string USP_ADDRESSTYPECODE_GETBYID = "USP_ADDRESSTYPECODE_GETBYID";
        public const string USP_ADDRESSTYPECODE_UPDATE = "USP_ADDRESSTYPECODE_UPDATE";

        public const string USP_EMAILADDRESSTYPECODE_CREATE = "USP_EMAILADDRESSTYPECODE_CREATE";
        public const string USP_EMAILADDRESSTYPECODE_DELETE = "USP_EMAILADDRESSTYPECODE_DELETE";
        public const string USP_EMAILADDRESSTYPECODE_GETALL = "USP_EMAILADDRESSTYPECODE_GETALL";
        public const string USP_EMAILADDRESSTYPECODE_GETBYID = "USP_EMAILADDRESSTYPECODE_GETBYID";
        public const string USP_EMAILADDRESSTYPECODE_UPDATE = "USP_EMAILADDRESSTYPECODE_UPDATE";

        public const string USP_PHONETYPECODE_CREATE = "USP_PHONETYPECODE_CREATE";
        public const string USP_PHONETYPECODE_DELETE = "USP_PHONETYPECODE_DELETE";
        public const string USP_PHONETYPECODE_GETALL = "USP_PHONETYPECODE_GETALL";
        public const string USP_PHONETYPECODE_GETBYID = "USP_PHONETYPECODE_GETBYID";
        public const string USP_PHONETYPECODE_UPDATE = "USP_PHONETYPECODE_UPDATE";

        //formatted code table sprocs
        public const string USP_STATEFORMATTEDTYPECODE_CREATE = "USP_STATEFORMATTEDTYPECODE_CREATE";
        public const string USP_STATEFORMATTEDTYPECODE_GETBYID = "USP_STATEFORMATTEDTYPECODE_GETBYID";
        public const string USP_STATEFORMATTEDTYPECODE_GETALL = "USP_STATEFORMATTEDTYPECODE_GETALL";
        public const string USP_STATEFORMATTEDTYPECODE_DELETE = "USP_STATEFORMATTEDTYPECODE_DELETE";

        public const string USP_COUNTRYFORMATTEDTYPECODE_CREATE = "USP_COUNTRYFORMATTEDTYPECODE_CREATE";
        public const string USP_COUNTRYFORMATTEDTYPECODE_GETBYID = "USP_COUNTRYFORMATTEDTYPECODE_GETBYID";
        public const string USP_COUNTRYFORMATTEDTYPECODE_DELETE = "USP_COUNTRYFORMATTEDTYPECODE_DELETE";
        public const string USP_COUNTRYFORMATTEDTYPECODE_GETALL = "USP_COUNTRYFORMATTEDTYPECODE_GETALL";
    }
}